At 14:34 +0300 on 12/7/98, Andy wrote:
> We use Prostgres 6.3.2 for our production system, but the Postgres
> tables is growing when the data updated (time travel?). Could any one
> help me to stop this time travel problem, since it make our system slow,
> and data corrputed frequently, our table size is about 150 MB (after
> vacuum), and 210 MB (before vacuum). The table is updated about 100
> thousands time per day, and we do the daily vacuum for the table.
Explain: does the table grow relative to what it is supposed to contain
even *after* you do the vacuum? Because growing prior to vacuum is
expected. Nothing is actually deleted until vacuum is performed.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma